﻿<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="thongke.ascx.cs" Inherits="Thv.admin.Pages.thongke" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v11.1.Export, Version=11.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView.Export" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v11.1, Version=11.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxCallbackPanel" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxGridView.v11.1, Version=11.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v11.1, Version=11.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.v11.1, Version=11.1.8.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxPanel" TagPrefix="dx" %>
<br />
<dx:ASPxCallbackPanel ID="ASPxCallbackPanel1" runat="server" Width="100%" ClientInstanceName="cbPanel"
                OnCallback="cbPanel_Callback">
    <PanelCollection>
        <dx:PanelContent runat="server" SupportsDisabledAttribute="True">
            <table width="100%">
                <tr>
                    <td style="width: 10%">
                        &nbsp;
                    </td>
                    <td style="width: 80%" colspan="4">
                        &nbsp;
                    </td>
                    <td style="width: 10%">
                        &nbsp;
                    </td>
                </tr>
                <tr>
                    <td>
                        &nbsp;
                    </td>
                    <td style="width: 5%">
                        Từ ngày:
                    </td>
                    <td style="width: 15%">
                        <dx:ASPxDateEdit ID="txtFrom" runat="server" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                            CssPostfix="Office2010Blue" Spacing="0" DisplayFormatString="dd/MM/yyyy"
                            SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" Height="26px">
                            <CalendarProperties>
                                <HeaderStyle Spacing="1px" />
                            </CalendarProperties>
                            <ButtonStyle Width="13px">
                            </ButtonStyle>
                        </dx:ASPxDateEdit>
                    </td>
                    <td style="width: 5%">
                        Đến ngày
                    </td>
                    <td style="width: 75%">
                        <dx:ASPxDateEdit ID="txtTo" runat="server" DisplayFormatString="dd/MM/yyyy" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" 
                            CssPostfix="Office2010Blue" Spacing="0" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                            Style="float: left; margin-right: 20px" Height="26px">
                            <CalendarProperties>
                                <HeaderStyle Spacing="1px" />
                            </CalendarProperties>
                            <ButtonStyle Width="13px">
                            </ButtonStyle>
                        </dx:ASPxDateEdit>
                        <dx:ASPxButton ID="ASPxButton1" runat="server" Text="Xem" Style="float: left; margin-right: 50px"
                            CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css" CssPostfix="Office2010Blue"
                            SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css" 
                            AutoPostBack="False">
                            <ClientSideEvents Click="function(s, e) {
	cbPanel.PerformCallback('Timkiem')
}" />
                        </dx:ASPxButton>
                        <dx:ASPxButton ID="ASPxButton2" runat="server" Text="Lưu bảng tạm" Style="float: left;
                            margin-right: 10px" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                            CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                            Width="150px" AutoPostBack="False">
                            <ClientSideEvents Click="function(s, e) {
	cbPanel.PerformCallback('Luu')
}" />
                        </dx:ASPxButton>
                        <dx:ASPxButton ID="ASPxButton3" runat="server" Text="Xuất Exels" Style="float: left;
                            margin-right: 10px" CssFilePath="~/App_Themes/Office2010Blue/{0}/styles.css"
                            CssPostfix="Office2010Blue" SpriteCssFilePath="~/App_Themes/Office2010Blue/{0}/sprite.css"
                            UseSubmitBehavior="False" OnClick="btnXlsxExport1_Click" 
                            AutoPostBack="False">
                        </dx:ASPxButton>
                    </td>
                    <td>
                        &nbsp;
                    </td>
                </tr>
                <tr>
                    <td>
                    </td>
                    <td colspan="4">
                        <dx:ASPxGridView ID="grvTV" runat="server" AutoGenerateColumns="False" KeyFieldName="ID"
                            CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" Width="100%"
                            OnAfterPerformCallback="grvTV_AfterPerformCallback" OnLoad="grvTV_Load">
                            <SettingsBehavior AllowFocusedRow="True"></SettingsBehavior>
                            <Columns>
                                <dx:GridViewBandColumn Caption="">
                                    <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Font-Size="15px" />
                                    <HeaderCaptionTemplate>
                                        BẢNG THỐNG KÊ TỔNG QUÁT</HeaderCaptionTemplate>
                                    <Columns>
                                        <dx:GridViewDataTextColumn Caption=" " VisibleIndex="1" FieldName="Theloai" Width="10%">
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Số cũ" VisibleIndex="2" FieldName="Soluongcu" Width="20%"
                                            HeaderStyle-HorizontalAlign="Center">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                            <CellStyle HorizontalAlign="Right">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Số mới" VisibleIndex="3" FieldName="Soluongmoi" Width="20%"
                                            HeaderStyle-HorizontalAlign="Center">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                            <CellStyle HorizontalAlign="Right">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Tổng" VisibleIndex="4" FieldName="Tongso" Width="10%"
                                            HeaderStyle-HorizontalAlign="Center">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                            <CellStyle HorizontalAlign="Right">
                                            </CellStyle>
                                        </dx:GridViewDataTextColumn>
                                    </Columns>
                                </dx:GridViewBandColumn>
                            </Columns>
                            <SettingsPager NumericButtonCount="100" PageSize="100">
                            </SettingsPager>
                            <Settings ShowFilterRowMenu="True" />
                            <Images SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css">
                                <LoadingPanelOnStatusBar Url="~/App_Themes/DevEx/GridView/StatusBarLoading.gif">
                                </LoadingPanelOnStatusBar>
                                <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
                                </LoadingPanel>
                            </Images>
                            <ImagesFilterControl>
                                <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
                                </LoadingPanel>
                            </ImagesFilterControl>
                            <Styles CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx">
                                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                                </Header>
                                <LoadingPanel ImageSpacing="5px">
                                </LoadingPanel>
                            </Styles>
                            <StylesEditors ButtonEditCellSpacing="0">
                                <ProgressBar Height="21px">
                                </ProgressBar>
                            </StylesEditors>
                        </dx:ASPxGridView>
                    </td>
                    <td>
                    </td>
                </tr>
                <tr>
                    <td>
                        &nbsp;
                    </td>
                    <td colspan="4">
                        &nbsp;
                    </td>
                    <td>
                        &nbsp;
                    </td>
                </tr>
                <tr>
                    <td>
                        &nbsp;
                    </td>
                    <td colspan="4">
                        <dx:ASPxGridView ID="grvTV0" runat="server" AutoGenerateColumns="False" KeyFieldName="ID"
                            CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx" Width="100%"
                            OnAfterPerformCallback="grvTV0_AfterPerformCallback" OnLoad="grvTV0_Load">
                            <SettingsBehavior AllowFocusedRow="True"></SettingsBehavior>
                            <Columns>
                                <dx:GridViewBandColumn Caption="">
                                    <HeaderStyle Font-Bold="True" HorizontalAlign="Center" Font-Size="15px" />
                                    <HeaderCaptionTemplate>
                                        BẢNG THỐNG KÊ HỆ THỐNG</HeaderCaptionTemplate>
                                    <Columns>
                                        <dx:GridViewDataTextColumn Caption="STT" VisibleIndex="0" FieldName="index" Width="10%"
                                            HeaderStyle-HorizontalAlign="Center">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="UserName" VisibleIndex="1" FieldName="UserName"
                                            HeaderStyle-HorizontalAlign="Center" Width="20%">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Tên" VisibleIndex="4" FieldName="FirtName" HeaderStyle-HorizontalAlign="Center">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Tư cách " VisibleIndex="2" FieldName="capbac"
                                            HeaderStyle-HorizontalAlign="Center" Width="20%">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Họ và chữ lót" FieldName="Lastname" VisibleIndex="3"
                                            HeaderStyle-HorizontalAlign="Center" Width="10%">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Số CMND" VisibleIndex="4" FieldName="cmnd" HeaderStyle-HorizontalAlign="Center"
                                            Width="35%">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Số tài khoản" VisibleIndex="5" HeaderStyle-HorizontalAlign="Center"
                                            FieldName="visa">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewDataTextColumn Caption="Tên ngân hàng" VisibleIndex="6" HeaderStyle-HorizontalAlign="Center"
                                            FieldName="officename">
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewDataTextColumn>
                                        <dx:GridViewBandColumn Caption="Thành Viên" HeaderStyle-HorizontalAlign="Center">
                                            <Columns>
                                                <dx:GridViewDataTextColumn Caption="Trực tiếp mới" VisibleIndex="7" HeaderStyle-HorizontalAlign="Center"
                                                    FieldName="hhtructiep1">
                                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn Caption="Gián tiếp mới" VisibleIndex="8" HeaderStyle-HorizontalAlign="Center"
                                                    FieldName="hhgiantiep1">
                                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                                </dx:GridViewDataTextColumn>
                                            </Columns>
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewBandColumn>
                                        <dx:GridViewBandColumn Caption="Cộng Tác Viên" HeaderStyle-HorizontalAlign="Center">
                                            <Columns>
                                                <dx:GridViewDataTextColumn Caption="Trực tiếp mới" VisibleIndex="9" HeaderStyle-HorizontalAlign="Center"
                                                    FieldName="hhtructiep2">
                                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                                </dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn Caption="Gián tiếp mới" VisibleIndex="10" HeaderStyle-HorizontalAlign="Center"
                                                    FieldName="hhgiantiep2">
                                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                                </dx:GridViewDataTextColumn>
                                            </Columns>
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewBandColumn>
                                        <dx:GridViewBandColumn Caption="Thưởng Danh Hiệu" HeaderStyle-HorizontalAlign="Center">
                                            <Columns>
                                                <dx:GridViewDataTextColumn Caption="F10-&gt;F14" VisibleIndex="12" HeaderStyle-HorizontalAlign="Center"
                                                    FieldName="thuongdanhhieu">
                                                    <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                                </dx:GridViewDataTextColumn>
                                            </Columns>
                                            <HeaderStyle HorizontalAlign="Center"></HeaderStyle>
                                        </dx:GridViewBandColumn>
                                    </Columns>
                                </dx:GridViewBandColumn>
                            </Columns>
                            <SettingsPager NumericButtonCount="100" PageSize="100">
                            </SettingsPager>
                            <Images SpriteCssFilePath="~/App_Themes/DevEx/{0}/sprite.css">
                                <LoadingPanelOnStatusBar Url="~/App_Themes/DevEx/GridView/StatusBarLoading.gif">
                                </LoadingPanelOnStatusBar>
                                <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
                                </LoadingPanel>
                            </Images>
                            <ImagesFilterControl>
                                <LoadingPanel Url="~/App_Themes/DevEx/GridView/Loading.gif">
                                </LoadingPanel>
                            </ImagesFilterControl>
                            <Styles CssFilePath="~/App_Themes/DevEx/{0}/styles.css" CssPostfix="DevEx">
                                <Header ImageSpacing="5px" SortingImageSpacing="5px">
                                </Header>
                                <LoadingPanel ImageSpacing="5px">
                                </LoadingPanel>
                            </Styles>
                            <StylesEditors ButtonEditCellSpacing="0">
                                <ProgressBar Height="21px">
                                </ProgressBar>
                            </StylesEditors>
                        </dx:ASPxGridView>
                        <dx:ASPxGridViewExporter ID="grvExpord" runat="server" GridViewID="grvTV0">
                        </dx:ASPxGridViewExporter>
                    </td>
                    <td>
                        &nbsp;
                    </td>
                </tr>
            </table>
        </dx:PanelContent>
    </PanelCollection>
</dx:ASPxCallbackPanel>
